SHOW FULL COLUMNS FROM `mtr_bus_route` [ RunTime:0.002908s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-572-O-0' LIMIT 1 [ RunTime:0.000247s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-572-O-0' LIMIT 1 [ RunTime:0.000214s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-572-I-0' LIMIT 1 [ RunTime:0.003689s ]
SELECT `id`,`no`,`co`,`name`,`orig`,`fare`,`freq`,`dest`,`service_type`,`stop_list` FROM `mtr_bus_route` `r` WHERE `r`.`id` = 'RMB-572-I-0' LIMIT 1 [ RunTime:0.000253s ]
SHOW FULL COLUMNS FROM `mtr_bus_stop` [ RunTime:0.000470s ]
SELECT `id`,`name` FROM `mtr_bus_stop` WHERE `id` IN ('RMB-23211','RMB-23213','RMB-23220','RMB-23221','RMB-23222','RMB-23223','RMB-23225','RMB-23226','RMB-23227') [ RunTime:0.000290s ]
SELECT `id`,`no`,`co`,`name`,`stop_list`,`orig`,`dest` FROM `mtr_bus_route` `r` WHERE `r`.`bound` = 'O' AND ( JSON_CONTAINS(stop_list, '"RMB-23211"') ) LIMIT 10 [ RunTime:0.061651s ]